﻿CREATE TABLE [dbo].[ASMS_Package]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Businessid] uniqueidentifier,
	[StationId] uniqueidentifier,
	[Code] nvarchar(32) NOT NULL,
    [Name] nvarchar(32) NOT NULL,
	[StartSaleTime] datetime NOT NULL,
	[StopSaleTime] datetime NOT NULL,
	[ExpiringDate] datetime NOT NULL,
	[Duration] int NOT NULL,
	[DurationType] int NOT NULL,
	[Price] money NOT NULL,
	[MarketPrice] money NOT NULL,
	[SalesCommission] money,
	[SalesCommissionType] int,
	[TechnicianCommission] money,
	[TechnicianCommissionType] int,
	[Description] nvarchar(256),
	[RebuyCount] int,
    [PackageAccessibility] int NOT NULL,
	[Status] int NOT NULL,
	[Creator] nvarchar(64) NOT NULL,
	[CreatedTime] datetime NOT NULL
)
